
# Import Libraries 
import pandas as pd
import seaborn as sns
import numpy as npy

import matplotlib
import matplotlib.pyplot as plt
plt.style.use('ggplot')
from matplotlib.pyplot import figure

%matplotlib inline
matplotlib.rcParams['figure.figsize'] = (12,8) # Adjusts the configuration of the plots we will create

# read in the date
df = pd.read_csv(r'C:\Users\student\Downloads\archive\movies.csv')


# An overview of our data

df.head()


# Odering the data by gross value

df.sort_values(by=['gross'], inplace=False, ascending=False)


# Drop rows with at least one null value
# using dropna() function

df.dropna(inplace=True)


# Dropping duplicate rows

df.drop_duplicates()


# Changing the datatype of bugdet and gross - to remove decimal places

df['budget'] = df['budget'].astype(npy.int64)
df['gross'] = df['gross'].astype(npy.int64)


# Finding correlations
# Scatter plot with bugdet vs gross

plt.scatter(x=df['budget'], y=df['gross'])
plt.title('Budget vs Gross Earnings')
plt.xlabel('Gross Earnings')
plt.ylabel('Budget for Film')

Text(0, 0.5, 'Budget for Film')


# Plot the budget vs gross using seaborn

sns.regplot(x='budget', y='gross', data = df, scatter_kws={"color":"red"}, line_kws={"color":"blue"})
plt.show()


# Let's start looking at the correlation


df.corr(method='pearson', numeric_only=True)


# High correlation between budget and gross


correlation_matrix = df.corr(method='pearson', numeric_only=True)
sns.heatmap(correlation_matrix, annot=True)
plt.title('Correlation Matrix for Numeric Features')
plt.xlabel('Movie Features')
plt.ylabel('Movie Features')
plt.show()


# Company* vs Gross Earnings 

df_numeric = df

for col_name in df_numeric.columns:
    if (df_numeric[col_name].dtype == 'object'):
        df_numeric[col_name] = df_numeric[col_name].astype('category')
        df_numeric[col_name] = df_numeric[col_name].cat.codes

df_numeric.head()


correlation_matrix = df_numeric.corr(method='pearson', numeric_only=True)
sns.heatmap(correlation_matrix, annot=True)
plt.title('Correlation Matrix for All Features')
plt.xlabel('Movie Features')
plt.ylabel('Movie Features')
plt.show()


df_numeric.corr()


correlation_matrix = df_numeric.corr()
corr_pairs = correlation_matrix.unstack()
corr_pairs

name      name        1.000000
          rating     -0.029234
          genre       0.010996
          year        0.025542
          released   -0.006152
          score       0.014450
          votes       0.012615
          director    0.015246
          writer      0.012880
          star       -0.006882
          country    -0.025490
          budget      0.023392
          gross       0.005639
          company     0.021697
          runtime     0.010850
rating    name       -0.029234
          rating      1.000000
          genre       0.147796
          year        0.019499
          released    0.018083
          score       0.065983
          votes       0.006031
          director    0.014656
          writer     -0.003149
          star        0.009196
          country     0.008230
          budget     -0.203946
          gross      -0.181906
          company    -0.092357
          runtime     0.140792
genre     name        0.010996
          rating      0.147796
          genre       1.000000
          year       -0.073167
          released    0.022142
          score       0.035106
          votes      -0.135990
          director   -0.008553
          writer      0.017578
          star        0.003341
          country    -0.009164
          budget     -0.368523
          gross      -0.244101
          company    -0.071334
          runtime    -0.059237
year      name        0.025542
          rating      0.019499
          genre      -0.073167
          year        1.000000
          released   -0.001740
          score       0.056386
          votes       0.206021
          director   -0.038354
          writer     -0.025908
          star       -0.032157
          country    -0.066748
          budget      0.327722
          gross       0.274321
          company    -0.014333
          runtime     0.075077
released  name       -0.006152
          rating      0.018083
          genre       0.022142
          year       -0.001740
          released    1.000000
          score       0.045874
          votes       0.028833
          director    0.002308
          writer      0.008072
          star        0.015706
          country    -0.017228
          budget      0.019952
          gross       0.008501
          company    -0.002407
          runtime     0.008975
score     name        0.014450
          rating      0.065983
          genre       0.035106
          year        0.056386
          released    0.045874
          score       1.000000
          votes       0.474256
          director    0.005413
          writer      0.012843
          star        0.007296
          country    -0.043051
          budget      0.072001
          gross       0.222556
          company     0.020656
          runtime     0.414068
votes     name        0.012615
          rating      0.006031
          genre      -0.135990
          year        0.206021
          released    0.028833
          score       0.474256
          votes       1.000000
          director   -0.010376
          writer     -0.005316
          star       -0.017638
          country     0.041551
          budget      0.439675
          gross       0.614751
          company     0.118470
          runtime     0.352303
director  name        0.015246
          rating      0.014656
          genre      -0.008553
          year       -0.038354
          released    0.002308
          score       0.005413
          votes      -0.010376
          director    1.000000
          writer      0.261735
          star        0.036593
          country     0.011133
          budget     -0.009662
          gross      -0.029560
          company    -0.008223
          runtime     0.017433
writer    name        0.012880
          rating     -0.003149
          genre       0.017578
          year       -0.025908
          released    0.008072
          score       0.012843
          votes      -0.005316
          director    0.261735
          writer      1.000000
          star        0.018520
          country     0.022488
          budget     -0.039466
          gross      -0.035885
          company    -0.003697
          runtime    -0.017561
star      name       -0.006882
          rating      0.009196
          genre       0.003341
          year       -0.032157
          released    0.015706
          score       0.007296
          votes      -0.017638
          director    0.036593
          writer      0.018520
          star        1.000000
          country    -0.009990
          budget     -0.021473
          gross      -0.000004
          company     0.014082
          runtime     0.010108
country   name       -0.025490
          rating      0.008230
          genre      -0.009164
          year       -0.066748
          released   -0.017228
          score      -0.043051
          votes       0.041551
          director    0.011133
          writer      0.022488
          star       -0.009990
          country     1.000000
          budget      0.052977
          gross       0.060078
          company     0.048569
          runtime    -0.034477
budget    name        0.023392
          rating     -0.203946
          genre      -0.368523
          year        0.327722
          released    0.019952
          score       0.072001
          votes       0.439675
          director   -0.009662
          writer     -0.039466
          star       -0.021473
          country     0.052977
          budget      1.000000
          gross       0.740247
          company     0.170235
          runtime     0.318695
gross     name        0.005639
          rating     -0.181906
          genre      -0.244101
          year        0.274321
          released    0.008501
          score       0.222556
          votes       0.614751
          director   -0.029560
          writer     -0.035885
          star       -0.000004
          country     0.060078
          budget      0.740247
          gross       1.000000
          company     0.149553
          runtime     0.275796
company   name        0.021697
          rating     -0.092357
          genre      -0.071334
          year       -0.014333
          released   -0.002407
          score       0.020656
          votes       0.118470
          director   -0.008223
          writer     -0.003697
          star        0.014082
          country     0.048569
          budget      0.170235
          gross       0.149553
          company     1.000000
          runtime     0.037585
runtime   name        0.010850
          rating      0.140792
          genre      -0.059237
          year        0.075077
          released    0.008975
          score       0.414068
          votes       0.352303
          director    0.017433
          writer     -0.017561
          star        0.010108
          country    -0.034477
          budget      0.318695
          gross       0.275796
          company     0.037585
          runtime     1.000000
dtype: float64


sorted_pairs = corr_pairs.sort_values()
sorted_pairs

budget    genre      -0.368523
genre     budget     -0.368523
          gross      -0.244101
gross     genre      -0.244101
budget    rating     -0.203946
rating    budget     -0.203946
          gross      -0.181906
gross     rating     -0.181906
genre     votes      -0.135990
votes     genre      -0.135990
company   rating     -0.092357
rating    company    -0.092357
genre     year       -0.073167
year      genre      -0.073167
genre     company    -0.071334
company   genre      -0.071334
year      country    -0.066748
country   year       -0.066748
genre     runtime    -0.059237
runtime   genre      -0.059237
country   score      -0.043051
score     country    -0.043051
budget    writer     -0.039466
writer    budget     -0.039466
director  year       -0.038354
year      director   -0.038354
writer    gross      -0.035885
gross     writer     -0.035885
country   runtime    -0.034477
runtime   country    -0.034477
star      year       -0.032157
year      star       -0.032157
director  gross      -0.029560
gross     director   -0.029560
name      rating     -0.029234
rating    name       -0.029234
year      writer     -0.025908
writer    year       -0.025908
country   name       -0.025490
name      country    -0.025490
budget    star       -0.021473
star      budget     -0.021473
votes     star       -0.017638
star      votes      -0.017638
writer    runtime    -0.017561
runtime   writer     -0.017561
country   released   -0.017228
released  country    -0.017228
company   year       -0.014333
year      company    -0.014333
director  votes      -0.010376
votes     director   -0.010376
country   star       -0.009990
star      country    -0.009990
budget    director   -0.009662
director  budget     -0.009662
country   genre      -0.009164
genre     country    -0.009164
          director   -0.008553
director  genre      -0.008553
          company    -0.008223
company   director   -0.008223
star      name       -0.006882
name      star       -0.006882
released  name       -0.006152
name      released   -0.006152
votes     writer     -0.005316
writer    votes      -0.005316
          company    -0.003697
company   writer     -0.003697
writer    rating     -0.003149
rating    writer     -0.003149
company   released   -0.002407
released  company    -0.002407
          year       -0.001740
year      released   -0.001740
gross     star       -0.000004
star      gross      -0.000004
director  released    0.002308
released  director    0.002308
star      genre       0.003341
genre     star        0.003341
score     director    0.005413
director  score       0.005413
name      gross       0.005639
gross     name        0.005639
rating    votes       0.006031
votes     rating      0.006031
score     star        0.007296
star      score       0.007296
released  writer      0.008072
writer    released    0.008072
rating    country     0.008230
country   rating      0.008230
gross     released    0.008501
released  gross       0.008501
          runtime     0.008975
runtime   released    0.008975
star      rating      0.009196
rating    star        0.009196
star      runtime     0.010108
runtime   star        0.010108
          name        0.010850
name      runtime     0.010850
          genre       0.010996
genre     name        0.010996
director  country     0.011133
country   director    0.011133
name      votes       0.012615
votes     name        0.012615
score     writer      0.012843
writer    score       0.012843
name      writer      0.012880
writer    name        0.012880
company   star        0.014082
star      company     0.014082
score     name        0.014450
name      score       0.014450
director  rating      0.014656
rating    director    0.014656
director  name        0.015246
name      director    0.015246
released  star        0.015706
star      released    0.015706
director  runtime     0.017433
runtime   director    0.017433
genre     writer      0.017578
writer    genre       0.017578
released  rating      0.018083
rating    released    0.018083
star      writer      0.018520
writer    star        0.018520
rating    year        0.019499
year      rating      0.019499
budget    released    0.019952
released  budget      0.019952
score     company     0.020656
company   score       0.020656
          name        0.021697
name      company     0.021697
genre     released    0.022142
released  genre       0.022142
writer    country     0.022488
country   writer      0.022488
name      budget      0.023392
budget    name        0.023392
year      name        0.025542
name      year        0.025542
votes     released    0.028833
released  votes       0.028833
score     genre       0.035106
genre     score       0.035106
director  star        0.036593
star      director    0.036593
runtime   company     0.037585
company   runtime     0.037585
votes     country     0.041551
country   votes       0.041551
score     released    0.045874
released  score       0.045874
company   country     0.048569
country   company     0.048569
budget    country     0.052977
country   budget      0.052977
year      score       0.056386
score     year        0.056386
gross     country     0.060078
country   gross       0.060078
rating    score       0.065983
score     rating      0.065983
          budget      0.072001
budget    score       0.072001
runtime   year        0.075077
year      runtime     0.075077
company   votes       0.118470
votes     company     0.118470
rating    runtime     0.140792
runtime   rating      0.140792
rating    genre       0.147796
genre     rating      0.147796
gross     company     0.149553
company   gross       0.149553
          budget      0.170235
budget    company     0.170235
votes     year        0.206021
year      votes       0.206021
score     gross       0.222556
gross     score       0.222556
writer    director    0.261735
director  writer      0.261735
gross     year        0.274321
year      gross       0.274321
gross     runtime     0.275796
runtime   gross       0.275796
          budget      0.318695
budget    runtime     0.318695
year      budget      0.327722
budget    year        0.327722
votes     runtime     0.352303
runtime   votes       0.352303
          score       0.414068
score     runtime     0.414068
votes     budget      0.439675
budget    votes       0.439675
votes     score       0.474256
score     votes       0.474256
votes     gross       0.614751
gross     votes       0.614751
          budget      0.740247
budget    gross       0.740247
name      name        1.000000
director  director    1.000000
gross     gross       1.000000
budget    budget      1.000000
country   country     1.000000
star      star        1.000000
writer    writer      1.000000
votes     votes       1.000000
score     score       1.000000
released  released    1.000000
year      year        1.000000
genre     genre       1.000000
rating    rating      1.000000
company   company     1.000000
runtime   runtime     1.000000
dtype: float64


high_corr = sorted_pairs[(sorted_pairs)>0.5]
high_corr

votes     gross       0.614751
gross     votes       0.614751
          budget      0.740247
budget    gross       0.740247
name      name        1.000000
director  director    1.000000
gross     gross       1.000000
budget    budget      1.000000
country   country     1.000000
star      star        1.000000
writer    writer      1.000000
votes     votes       1.000000
score     score       1.000000
released  released    1.000000
year      year        1.000000
genre     genre       1.000000
rating    rating      1.000000
company   company     1.000000
runtime   runtime     1.000000
dtype: float64


# Votes and Budget have the highest correlation to gross earnings
# Company has a low correlation with gross earnings

	name	rating	genre	year	released	score	votes	director	writer	star	country	budget	gross	company	runtime
0	The Shining	R	Drama	1980	June 13, 1980 (United States)	8.4	927000.0	Stanley Kubrick	Stephen King	Jack Nicholson	United Kingdom	19000000.0	46998772.0	Warner Bros.	146.0
1	The Blue Lagoon	R	Adventure	1980	July 2, 1980 (United States)	5.8	65000.0	Randal Kleiser	Henry De Vere Stacpoole	Brooke Shields	United States	4500000.0	58853106.0	Columbia Pictures	104.0
2	Star Wars: Episode V - The Empire Strikes Back	PG	Action	1980	June 20, 1980 (United States)	8.7	1200000.0	Irvin Kershner	Leigh Brackett	Mark Hamill	United States	18000000.0	538375067.0	Lucasfilm	124.0
3	Airplane!	PG	Comedy	1980	July 2, 1980 (United States)	7.7	221000.0	Jim Abrahams	Jim Abrahams	Robert Hays	United States	3500000.0	83453539.0	Paramount Pictures	88.0
4	Caddyshack	R	Comedy	1980	July 25, 1980 (United States)	7.3	108000.0	Harold Ramis	Brian Doyle-Murray	Chevy Chase	United States	6000000.0	39846344.0	Orion Pictures	98.0

	name	rating	genre	year	released	score	votes	director	writer	star	country	budget	gross	company	runtime
0	4692	6	6	1980	1304	8.4	927000.0	1795	2832	699	46	19000000	46998772	1426	146.0
1	3929	6	1	1980	1127	5.8	65000.0	1578	1158	214	47	4500000	58853106	452	104.0
2	3641	4	0	1980	1359	8.7	1200000.0	757	1818	1157	47	18000000	538375067	945	124.0
3	204	4	4	1980	1127	7.7	221000.0	889	1413	1474	47	3500000	83453539	1108	88.0
4	732	6	4	1980	1170	7.3	108000.0	719	351	271	47	6000000	39846344	1083	98.0

	year	score	votes	budget	gross	runtime
year	1.000000	0.056386	0.206021	0.327722	0.274321	0.075077
score	0.056386	1.000000	0.474256	0.072001	0.222556	0.414068
votes	0.206021	0.474256	1.000000	0.439675	0.614751	0.352303
budget	0.327722	0.072001	0.439675	1.000000	0.740247	0.318695
gross	0.274321	0.222556	0.614751	0.740247	1.000000	0.275796
runtime	0.075077	0.414068	0.352303	0.318695	0.275796	1.000000

	name	rating	genre	year	released	score	votes	director	writer	star	country	budget	gross	company	runtime
name	1.000000	-0.029234	0.010996	0.025542	-0.006152	0.014450	0.012615	0.015246	0.012880	-0.006882	-0.025490	0.023392	0.005639	0.021697	0.010850
rating	-0.029234	1.000000	0.147796	0.019499	0.018083	0.065983	0.006031	0.014656	-0.003149	0.009196	0.008230	-0.203946	-0.181906	-0.092357	0.140792
genre	0.010996	0.147796	1.000000	-0.073167	0.022142	0.035106	-0.135990	-0.008553	0.017578	0.003341	-0.009164	-0.368523	-0.244101	-0.071334	-0.059237
year	0.025542	0.019499	-0.073167	1.000000	-0.001740	0.056386	0.206021	-0.038354	-0.025908	-0.032157	-0.066748	0.327722	0.274321	-0.014333	0.075077
released	-0.006152	0.018083	0.022142	-0.001740	1.000000	0.045874	0.028833	0.002308	0.008072	0.015706	-0.017228	0.019952	0.008501	-0.002407	0.008975
score	0.014450	0.065983	0.035106	0.056386	0.045874	1.000000	0.474256	0.005413	0.012843	0.007296	-0.043051	0.072001	0.222556	0.020656	0.414068
votes	0.012615	0.006031	-0.135990	0.206021	0.028833	0.474256	1.000000	-0.010376	-0.005316	-0.017638	0.041551	0.439675	0.614751	0.118470	0.352303
director	0.015246	0.014656	-0.008553	-0.038354	0.002308	0.005413	-0.010376	1.000000	0.261735	0.036593	0.011133	-0.009662	-0.029560	-0.008223	0.017433
writer	0.012880	-0.003149	0.017578	-0.025908	0.008072	0.012843	-0.005316	0.261735	1.000000	0.018520	0.022488	-0.039466	-0.035885	-0.003697	-0.017561
star	-0.006882	0.009196	0.003341	-0.032157	0.015706	0.007296	-0.017638	0.036593	0.018520	1.000000	-0.009990	-0.021473	-0.000004	0.014082	0.010108
country	-0.025490	0.008230	-0.009164	-0.066748	-0.017228	-0.043051	0.041551	0.011133	0.022488	-0.009990	1.000000	0.052977	0.060078	0.048569	-0.034477
budget	0.023392	-0.203946	-0.368523	0.327722	0.019952	0.072001	0.439675	-0.009662	-0.039466	-0.021473	0.052977	1.000000	0.740247	0.170235	0.318695
gross	0.005639	-0.181906	-0.244101	0.274321	0.008501	0.222556	0.614751	-0.029560	-0.035885	-0.000004	0.060078	0.740247	1.000000	0.149553	0.275796
company	0.021697	-0.092357	-0.071334	-0.014333	-0.002407	0.020656	0.118470	-0.008223	-0.003697	0.014082	0.048569	0.170235	0.149553	1.000000	0.037585
runtime	0.010850	0.140792	-0.059237	0.075077	0.008975	0.414068	0.352303	0.017433	-0.017561	0.010108	-0.034477	0.318695	0.275796	0.037585	1.000000

	name	rating	genre	year	released	score	votes	director	writer	star	country	budget	gross	company	runtime
5445	Avatar	PG-13	Action	2009	December 18, 2009 (United States)	7.8	1100000.0	James Cameron	James Cameron	Sam Worthington	United States	237000000.0	2.847246e+09	Twentieth Century Fox	162.0
7445	Avengers: Endgame	PG-13	Action	2019	April 26, 2019 (United States)	8.4	903000.0	Anthony Russo	Christopher Markus	Robert Downey Jr.	United States	356000000.0	2.797501e+09	Marvel Studios	181.0
3045	Titanic	PG-13	Drama	1997	December 19, 1997 (United States)	7.8	1100000.0	James Cameron	James Cameron	Leonardo DiCaprio	United States	200000000.0	2.201647e+09	Twentieth Century Fox	194.0
6663	Star Wars: Episode VII - The Force Awakens	PG-13	Action	2015	December 18, 2015 (United States)	7.8	876000.0	J.J. Abrams	Lawrence Kasdan	Daisy Ridley	United States	245000000.0	2.069522e+09	Lucasfilm	138.0
7244	Avengers: Infinity War	PG-13	Action	2018	April 27, 2018 (United States)	8.4	897000.0	Anthony Russo	Christopher Markus	Robert Downey Jr.	United States	321000000.0	2.048360e+09	Marvel Studios	149.0
7480	The Lion King	PG	Animation	2019	July 19, 2019 (United States)	6.9	222000.0	Jon Favreau	Jeff Nathanson	Donald Glover	United States	260000000.0	1.670728e+09	Walt Disney Pictures	118.0
6653	Jurassic World	PG-13	Action	2015	June 12, 2015 (United States)	7.0	593000.0	Colin Trevorrow	Rick Jaffa	Chris Pratt	United States	150000000.0	1.670516e+09	Universal Pictures	124.0
6043	The Avengers	PG-13	Action	2012	May 4, 2012 (United States)	8.0	1300000.0	Joss Whedon	Joss Whedon	Robert Downey Jr.	United States	220000000.0	1.518816e+09	Marvel Studios	143.0
6646	Furious 7	PG-13	Action	2015	April 3, 2015 (United States)	7.1	370000.0	James Wan	Chris Morgan	Vin Diesel	United States	190000000.0	1.515341e+09	Universal Pictures	137.0
7494	Frozen II	PG	Animation	2019	November 22, 2019 (United States)	6.8	148000.0	Chris Buck	Jennifer Lee	Kristen Bell	United States	150000000.0	1.450027e+09	Walt Disney Animation Studios	103.0
6644	Avengers: Age of Ultron	PG-13	Action	2015	May 1, 2015 (United States)	7.3	777000.0	Joss Whedon	Joss Whedon	Robert Downey Jr.	United States	250000000.0	1.402810e+09	Marvel Studios	141.0
7247	Black Panther	PG-13	Action	2018	February 16, 2018 (United States)	7.3	661000.0	Ryan Coogler	Ryan Coogler	Chadwick Boseman	United States	200000000.0	1.347598e+09	Marvel Studios	134.0
5845	Harry Potter and the Deathly Hallows: Part 2	PG-13	Adventure	2011	July 15, 2011 (United States)	8.1	790000.0	David Yates	Steve Kloves	Daniel Radcliffe	United Kingdom	125000000.0	1.342322e+09	Warner Bros.	130.0
7075	Star Wars: Episode VIII - The Last Jedi	PG-13	Action	2017	December 15, 2017 (United States)	7.0	581000.0	Rian Johnson	Rian Johnson	Daisy Ridley	United States	317000000.0	1.332699e+09	Walt Disney Pictures	152.0
7271	Jurassic World: Fallen Kingdom	PG-13	Action	2018	June 22, 2018 (United States)	6.2	277000.0	J.A. Bayona	Derek Connolly	Chris Pratt	United States	170000000.0	1.310466e+09	Universal Pictures	128.0
6262	Frozen	PG	Animation	2013	November 27, 2013 (United States)	7.4	585000.0	Chris Buck	Jennifer Lee	Kristen Bell	United States	150000000.0	1.281508e+09	Walt Disney Animation Studios	102.0
7072	Beauty and the Beast	PG	Family	2017	March 17, 2017 (United States)	7.1	283000.0	Bill Condon	Stephen Chbosky	Emma Watson	United States	160000000.0	1.264435e+09	Mandeville Films	129.0
7281	Incredibles 2	PG	Animation	2018	June 15, 2018 (United States)	7.6	263000.0	Brad Bird	Brad Bird	Craig T. Nelson	United States	200000000.0	1.244640e+09	Walt Disney Pictures	118.0
7055	The Fate of the Furious	PG-13	Action	2017	April 14, 2017 (United States)	6.6	214000.0	F. Gary Gray	Gary Scott Thompson	Vin Diesel	China	250000000.0	1.236005e+09	Universal Pictures	136.0
6244	Iron Man 3	PG-13	Action	2013	May 3, 2013 (United States)	7.1	779000.0	Shane Black	Drew Pearce	Robert Downey Jr.	United States	200000000.0	1.214811e+09	Marvel Studios	130.0
6688	Minions	PG	Animation	2015	July 10, 2015 (United States)	6.4	218000.0	Kyle Balda	Brian Lynch	Sandra Bullock	United States	74000000.0	1.159445e+09	Illumination Entertainment	91.0
6846	Captain America: Civil War	PG-13	Action	2016	May 6, 2016 (United States)	7.8	694000.0	Anthony Russo	Christopher Markus	Chris Evans	United States	250000000.0	1.153337e+09	Marvel Studios	147.0
7250	Aquaman	PG-13	Action	2018	December 21, 2018 (United States)	6.9	404000.0	James Wan	David Leslie Johnson-McGoldrick	Jason Momoa	United States	160000000.0	1.148486e+09	Warner Bros.	143.0
4245	The Lord of the Rings: The Return of the King	PG-13	Action	2003	December 17, 2003 (United States)	8.9	1700000.0	Peter Jackson	J.R.R. Tolkien	Elijah Wood	New Zealand	94000000.0	1.146031e+09	New Line Cinema	201.0
7458	Spider-Man: Far from Home	PG-13	Action	2019	July 2, 2019 (United States)	7.5	359000.0	Jon Watts	Chris McKenna	Tom Holland	United States	160000000.0	1.131928e+09	Columbia Pictures	129.0
7456	Captain Marvel	PG-13	Action	2019	March 8, 2019 (United States)	6.8	478000.0	Anna Boden	Anna Boden	Brie Larson	United States	160000000.0	1.128463e+09	Walt Disney Pictures	123.0
5878	Transformers: Dark of the Moon	PG-13	Action	2011	June 29, 2011 (United States)	6.2	390000.0	Michael Bay	Ehren Kruger	Shia LaBeouf	United States	195000000.0	1.123794e+09	Paramount Pictures	154.0
6059	Skyfall	PG-13	Action	2012	November 9, 2012 (United States)	7.7	642000.0	Sam Mendes	Neal Purvis	Daniel Craig	United Kingdom	200000000.0	1.108569e+09	Metro-Goldwyn-Mayer (MGM)	143.0
6494	Transformers: Age of Extinction	PG-13	Action	2014	June 27, 2014 (United States)	5.6	302000.0	Michael Bay	Ehren Kruger	Mark Wahlberg	United States	210000000.0	1.104054e+09	Paramount Pictures	165.0
2448	The Lion King	G	Animation	1994	June 24, 1994 (United States)	8.5	970000.0	Roger Allers	Irene Mecchi	Matthew Broderick	United States	45000000.0	1.083721e+09	Walt Disney Pictures	88.0
6047	The Dark Knight Rises	PG-13	Action	2012	July 20, 2012 (United States)	8.4	1600000.0	Christopher Nolan	Jonathan Nolan	Christian Bale	United Kingdom	250000000.0	1.081143e+09	Warner Bros.	164.0
7463	Star Wars: Episode IX - The Rise of Skywalker	PG-13	Action	2019	December 20, 2019 (United States)	6.5	394000.0	J.J. Abrams	Chris Terrio	Daisy Ridley	United States	275000000.0	1.078233e+09	Walt Disney Pictures	141.0
7450	Joker	R	Crime	2019	October 4, 2019 (United States)	8.4	1000000.0	Todd Phillips	Todd Phillips	Joaquin Phoenix	United States	55000000.0	1.074427e+09	Warner Bros.	122.0
7488	Toy Story 4	G	Animation	2019	June 21, 2019 (United States)	7.7	217000.0	Josh Cooley	John Lasseter	Tom Hanks	United States	200000000.0	1.073395e+09	Pixar Animation Studios	100.0
5685	Toy Story 3	G	Animation	2010	June 18, 2010 (United States)	8.2	776000.0	Lee Unkrich	John Lasseter	Tom Hanks	United States	200000000.0	1.066971e+09	Walt Disney Pictures	103.0
4852	Pirates of the Caribbean: Dead Man's Chest	PG-13	Action	2006	July 7, 2006 (United States)	7.3	668000.0	Gore Verbinski	Ted Elliott	Johnny Depp	United States	225000000.0	1.066180e+09	Walt Disney Pictures	151.0
6869	Rogue One: A Star Wars Story	PG-13	Action	2016	December 16, 2016 (United States)	7.8	572000.0	Gareth Edwards	Chris Weitz	Felicity Jones	United States	200000000.0	1.056058e+09	Lucasfilm	133.0
7481	Aladdin	PG	Adventure	2019	May 24, 2019 (United States)	6.9	239000.0	Guy Ritchie	John August	Will Smith	United Kingdom	183000000.0	1.050694e+09	Walt Disney Pictures	128.0
5860	Pirates of the Caribbean: on Stranger Tides	PG-13	Action	2011	May 20, 2011 (United States)	6.6	492000.0	Rob Marshall	Ted Elliott	Johnny Depp	United States	250000000.0	1.045714e+09	Walt Disney Pictures	136.0
7140	Despicable Me 3	PG	Animation	2017	June 30, 2017 (United States)	6.3	119000.0	Kyle Balda	Cinco Paul	Steve Carell	United States	80000000.0	1.034800e+09	Illumination Entertainment	89.0

	name	rating	genre	year	released	score	votes	director	writer	star	country	budget	gross	company	runtime
0	The Shining	R	Drama	1980	June 13, 1980 (United States)	8.4	927000.0	Stanley Kubrick	Stephen King	Jack Nicholson	United Kingdom	19000000.0	4.699877e+07	Warner Bros.	146.0
1	The Blue Lagoon	R	Adventure	1980	July 2, 1980 (United States)	5.8	65000.0	Randal Kleiser	Henry De Vere Stacpoole	Brooke Shields	United States	4500000.0	5.885311e+07	Columbia Pictures	104.0
2	Star Wars: Episode V - The Empire Strikes Back	PG	Action	1980	June 20, 1980 (United States)	8.7	1200000.0	Irvin Kershner	Leigh Brackett	Mark Hamill	United States	18000000.0	5.383751e+08	Lucasfilm	124.0
3	Airplane!	PG	Comedy	1980	July 2, 1980 (United States)	7.7	221000.0	Jim Abrahams	Jim Abrahams	Robert Hays	United States	3500000.0	8.345354e+07	Paramount Pictures	88.0
4	Caddyshack	R	Comedy	1980	July 25, 1980 (United States)	7.3	108000.0	Harold Ramis	Brian Doyle-Murray	Chevy Chase	United States	6000000.0	3.984634e+07	Orion Pictures	98.0
5	Friday the 13th	R	Horror	1980	May 9, 1980 (United States)	6.4	123000.0	Sean S. Cunningham	Victor Miller	Betsy Palmer	United States	550000.0	3.975460e+07	Paramount Pictures	95.0
6	The Blues Brothers	R	Action	1980	June 20, 1980 (United States)	7.9	188000.0	John Landis	Dan Aykroyd	John Belushi	United States	27000000.0	1.152299e+08	Universal Pictures	133.0
7	Raging Bull	R	Biography	1980	December 19, 1980 (United States)	8.2	330000.0	Martin Scorsese	Jake LaMotta	Robert De Niro	United States	18000000.0	2.340243e+07	Chartoff-Winkler Productions	129.0
8	Superman II	PG	Action	1980	June 19, 1981 (United States)	6.8	101000.0	Richard Lester	Jerry Siegel	Gene Hackman	United States	54000000.0	1.081857e+08	Dovemead Films	127.0
9	The Long Riders	R	Biography	1980	May 16, 1980 (United States)	7.0	10000.0	Walter Hill	Bill Bryden	David Carradine	United States	10000000.0	1.579519e+07	United Artists	100.0
10	Any Which Way You Can	PG	Action	1980	December 17, 1980 (United States)	6.1	18000.0	Buddy Van Horn	Stanford Sherman	Clint Eastwood	United States	15000000.0	7.068734e+07	The Malpaso Company	116.0
11	The Gods Must Be Crazy	PG	Adventure	1980	October 26, 1984 (United States)	7.3	54000.0	Jamie Uys	Jamie Uys	N!xau	South Africa	5000000.0	3.003178e+07	C.A.T. Films	109.0
12	Popeye	PG	Adventure	1980	December 12, 1980 (United States)	5.3	30000.0	Robert Altman	Jules Feiffer	Robin Williams	United States	20000000.0	4.982304e+07	Paramount Pictures	114.0
13	Ordinary People	R	Drama	1980	September 19, 1980 (United States)	7.7	49000.0	Robert Redford	Judith Guest	Donald Sutherland	United States	6000000.0	5.476692e+07	Paramount Pictures	124.0
14	Dressed to Kill	R	Crime	1980	July 25, 1980 (United States)	7.1	37000.0	Brian De Palma	Brian De Palma	Michael Caine	United States	6500000.0	3.189900e+07	Filmways Pictures	104.0
15	Somewhere in Time	PG	Drama	1980	October 3, 1980 (United States)	7.2	27000.0	Jeannot Szwarc	Richard Matheson	Christopher Reeve	United States	5100000.0	9.709597e+06	Rastar Pictures	103.0
17	9 to 5	PG	Comedy	1980	December 19, 1980 (United States)	6.9	29000.0	Colin Higgins	Patricia Resnick	Jane Fonda	United States	10000000.0	1.033007e+08	IPC Films	109.0
18	The Fog	R	Horror	1980	February 8, 1980 (United States)	6.8	66000.0	John Carpenter	John Carpenter	Adrienne Barbeau	United States	1000000.0	2.144878e+07	AVCO Embassy Pictures	89.0
20	Cruising	R	Crime	1980	February 15, 1980 (United States)	6.5	20000.0	William Friedkin	William Friedkin	Al Pacino	West Germany	11000000.0	1.981452e+07	Lorimar Film Entertainment	102.0
21	Heaven's Gate	R	Adventure	1980	April 24, 1981 (United States)	6.8	14000.0	Michael Cimino	Michael Cimino	Kris Kristofferson	United States	44000000.0	3.484523e+06	Partisan Productions	219.0
22	The Final Countdown	PG	Action	1980	August 1, 1980 (United States)	6.7	22000.0	Don Taylor	Thomas Hunter	Kirk Douglas	United States	12000000.0	1.664780e+07	Bryna Productions	103.0
23	Xanadu	PG	Fantasy	1980	August 8, 1980 (United States)	5.3	12000.0	Robert Greenwald	Richard Christian Danus	Olivia Newton-John	United States	20000000.0	2.276257e+07	Universal Pictures	96.0
28	Brubaker	R	Crime	1980	June 20, 1980 (United States)	7.2	17000.0	Stuart Rosenberg	W.D. Richter	Robert Redford	United States	9000000.0	3.712171e+07	Twentieth Century Fox	131.0
29	American Gigolo	R	Crime	1980	February 1, 1980 (United States)	6.2	22000.0	Paul Schrader	Paul Schrader	Richard Gere	United States	4800000.0	2.274367e+07	Paramount Pictures	117.0
33	Cattle Annie and Little Britches	PG	Drama	1980	April 24, 1981 (United States)	6.1	604.0	Lamont Johnson	David Eyre	Scott Glenn	United States	5100000.0	5.348160e+05	Cattle Annie Productions	97.0
35	Private Benjamin	R	Comedy	1980	October 10, 1980 (United States)	6.2	24000.0	Howard Zieff	Nancy Meyers	Goldie Hawn	United States	10000000.0	6.984735e+07	Warner Bros.	109.0
36	The Hollywood Knights	R	Comedy	1980	May 30, 1980 (United States)	6.3	4300.0	Floyd Mutrux	Floyd Mutrux	Tony Danza	United States	4000000.0	1.000000e+07	PolyGram Filmed Entertainment	91.0
37	Motel Hell	R	Comedy	1980	October 24, 1980 (United States)	6.0	11000.0	Kevin Connor	Robert Jaffe	Rory Calhoun	United States	3000000.0	6.342668e+06	Camp Hill	101.0
42	The Stunt Man	R	Action	1980	June 27, 1980 (United States)	7.1	9000.0	Richard Rush	Lawrence B. Marcus	Peter O'Toole	United States	3500000.0	7.063886e+06	Melvin Simon Productions	131.0
46	The Island	R	Action	1980	June 13, 1980 (United States)	5.3	3900.0	Michael Ritchie	Peter Benchley	Michael Caine	United States	22000000.0	1.571683e+07	Universal Pictures	109.0
48	The Nude Bomb	PG	Action	1980	May 9, 1980 (United States)	5.1	3100.0	Clive Donner	Mel Brooks	Don Adams	United States	15000000.0	1.466204e+07	Universal Pictures	94.0
50	Stardust Memories	PG	Comedy	1980	September 26, 1980 (United States)	7.3	22000.0	Woody Allen	Woody Allen	Woody Allen	United States	10000000.0	1.038900e+07	Jack Rollins & Charles H. Joffe Productions	89.0
51	Melvin and Howard	R	Comedy	1980	September 19, 1980 (United States)	6.8	4500.0	Jonathan Demme	Bo Goldman	Paul Le Mat	United States	7000000.0	4.309490e+06	Universal Pictures	95.0
53	Bronco Billy	PG	Action	1980	June 11, 1980 (United States)	6.1	11000.0	Clint Eastwood	Dennis Hackin	Clint Eastwood	United States	6500000.0	2.426566e+07	Warner Bros.	116.0
56	When Time Ran Out...	PG	Action	1980	March 28, 1980 (United States)	4.6	2600.0	James Goldstone	Gordon Thomas	Paul Newman	United States	20000000.0	3.763988e+06	International Cinema	121.0
57	Oh Heavenly Dog	PG	Comedy	1980	July 11, 1980 (United States)	5.4	2400.0	Joe Camp	Rod Browning	Chevy Chase	United States	6000000.0	6.216067e+06	Mulberry Square Productions	103.0
58	The Octagon	R	Action	1980	August 15, 1980 (United States)	5.1	5200.0	Eric Karson	Leigh Chapman	Chuck Norris	United States	4000000.0	1.897100e+07	American Cinema Productions	103.0
75	The Last Flight of Noah's Ark	G	Adventure	1980	June 25, 1980 (United States)	5.8	1300.0	Charles Jarrott	Ernest K. Gann	Elliott Gould	United States	6000000.0	1.100000e+07	Walt Disney Productions	97.0
77	Willie & Phil	R	Comedy	1980	August 15, 1980 (United States)	5.9	415.0	Paul Mazursky	Jean Gruault	Michael Ontkean	United States	5500000.0	4.400000e+06	Twentieth Century Fox	115.0
80	Phobia	R	Drama	1980	September 9, 1980 (United States)	4.0	546.0	John Huston	Gary Sherman	Paul Michael Glaser	Canada	5100000.0	5.916700e+04	Borough Park Productions	94.0